/ Archive Magazine CD 1995 / Archive Magazine CD 1995.iso / discs / pipeline / 4_06

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 41 72 63 68 69 76 65 00 | 68 01 00 00 54 03 00 00 |Archive.|h...T...|
|00000010| 28 00 00 00 64 00 00 00 | 00 00 00 00 00 00 00 00 |(...d...|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 82 49 74 65 72 61 74 69 | 6f 6e 00 00 ff ff ff ff |.Iterati|on......|
|00000070| 46 fd ff ff bc 2f fc 1e | 00 00 00 00 ff ff ff ff |F..../..|........|
|00000080| 90 00 00 80 82 4c 6f 61 | 6e 00 04 00 ee 00 00 00 |.....Loa|n.......|
|00000090| 3c 07 00 00 42 de fd ff | a0 61 ff f4 03 00 78 6e |<...B...|.a....xn|
|000000a0| 3c 07 00 00 24 00 00 00 | 82 52 65 61 64 4d 65 00 |<...$...|.ReadMe.|
|000000b0| ee 00 00 00 45 0f 00 00 | 42 de fd ff dc 33 01 f5 |....E...|B....3..|
|000000c0| 03 00 05 00 45 0f 00 00 | 84 07 00 00 00 00 34 00 |....E...|......4.|
|000000d0| c3 00 04 00 ee 00 00 00 | d4 ff ff ff 21 01 5d 07 |........|....!.].|
|000000e0| c0 62 1a 02 00 00 00 00 | 12 00 00 00 9a fd ff ff |.b......|........|
|000000f0| 82 53 74 61 72 74 55 70 | 00 00 00 00 ff ff ff ff |.StartUp|........|
|00000100| 46 fd ff ff d1 2f fc 1e | 00 00 00 00 ff ff ff ff |F..../..|........|
|00000110| 44 01 00 80 82 6e 65 77 | 5f 73 68 65 65 74 00 00 |D....new|_sheet..|
|00000120| f9 00 00 00 42 21 fd ff | 8d cc d2 ee 03 00 ef e8 |....B!..|........|
|00000130| f9 00 00 00 ed 16 00 00 | 82 6e 65 77 5f 77 6f 72 |........|.new_wor|
|00000140| 64 00 00 00 5c 01 00 00 | 42 21 fd ff 59 26 d4 ee |d...\...|B!..Y&..|
|00000150| 03 00 45 bf 5c 01 00 00 | 0a 18 00 00 82 52 65 61 |..E.\...|.....Rea|
|00000160| 64 4d 65 00 00 00 00 00 | ea 08 00 00 42 de fd ff |dMe.....|....B...|
|00000170| 61 0c 06 f5 03 00 c2 dc | ea 08 00 00 8a 19 00 00 |a.......|........|
|00000180| 00 00 0f 07 00 0d 00 00 | 00 00 00 00 0b 00 00 00 |........|........|
|00000190| 00 00 00 00 50 ff ff ff | 18 00 00 00 7c ff ff ff |....P...|....|...|
|000001a0| e4 fc 4d 07 00 00 00 00 | 00 00 00 00 00 00 00 00 |..M.....|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 46 69 6c 65 | 44 61 74 61 82 4c 6f 61 |....File|Data.Loa|
|00000360| 6e 00 04 00 ee 00 00 00 | 3c 07 00 00 42 de fd ff |n.......|<...B...|
|00000370| a0 61 ff f4 03 00 78 6e | 25 4f 50 25 54 4e 4e 0a |.a....xn|%OP%TNN.|
|00000380| 25 4f 50 25 4a 55 4e 0a | 25 4f 50 25 57 52 4e 0a |%OP%JUN.|%OP%WRN.|
|00000390| 25 4f 50 25 44 50 30 0a | 25 4f 50 25 44 46 54 0a |%OP%DP0.|%OP%DFT.|
|000003a0| 25 4f 50 25 47 52 59 0a | 25 4f 50 25 50 4c 35 37 |%OP%GRY.|%OP%PL57|
|000003b0| 0a 25 4f 50 25 54 4d 34 | 0a 25 4f 50 25 48 4d 30 |.%OP%TM4|.%OP%HM0|
|000003c0| 0a 25 4f 50 25 46 4d 34 | 0a 25 4f 50 25 42 4d 34 |.%OP%FM4|.%OP%BM4|
|000003d0| 0a 25 4f 50 25 4c 4d 38 | 0a 25 4f 50 25 52 49 59 |.%OP%LM8|.%OP%RIY|
|000003e0| 0a 25 43 4f 3a 41 2c 31 | 32 2c 37 32 25 57 68 61 |.%CO:A,1|2,72%Wha|
|000003f0| 74 20 6d 6f 6e 74 68 6c | 79 20 70 61 79 6d 65 6e |t monthl|y paymen|
|00000400| 74 20 77 6f 75 6c 64 20 | 6e 65 65 64 20 74 6f 20 |t would |need to |
|00000410| 62 65 20 6d 61 64 65 20 | 69 6e 20 6f 72 64 65 72 |be made |in order|
|00000420| 20 74 6f 20 0a 63 6f 76 | 65 72 20 74 68 65 20 69 | to .cov|er the i|
|00000430| 6e 74 65 72 65 73 74 20 | 61 63 63 72 75 65 64 20 |nterest |accrued |
|00000440| 6f 6e 20 74 68 65 20 70 | 72 69 6e 63 69 70 61 6c |on the p|rincipal|
|00000450| 3f 0a 0a 0a 0a 0a 25 52 | 25 50 72 69 6e 63 69 70 |?.....%R|%Princip|
|00000460| 61 6c 0a 25 56 25 25 52 | 25 25 44 30 25 31 30 30 |al.%V%%R|%%D0%100|
|00000470| 30 0a 25 52 25 52 65 74 | 75 72 6e 0a 25 56 25 25 |0.%R%Ret|urn.%V%%|
|00000480| 52 25 41 38 2a 28 28 28 | 42 38 2f 31 30 30 29 2b |R%A8*(((|B8/100)+|
|00000490| 31 29 5e 43 38 29 0a 0a | 0a 0a 0a 0a 57 68 65 72 |1)^C8)..|....Wher|
|000004a0| 65 20 69 73 20 74 68 65 | 20 62 72 65 61 6b 2d 65 |e is the| break-e|
|000004b0| 76 65 6e 20 70 6f 69 6e | 74 20 66 6f 72 20 61 20 |ven poin|t for a |
|000004c0| 6c 75 6d 70 20 73 75 6d | 20 61 67 61 69 6e 73 74 |lump sum| against|
|000004d0| 20 0a 72 65 67 75 6c 61 | 72 20 6d 6f 6e 74 68 6c | .regula|r monthl|
|000004e0| 79 20 70 61 79 6d 65 6e | 74 73 20 61 74 20 74 68 |y paymen|ts at th|
|000004f0| 65 20 73 61 6d 65 20 69 | 6e 74 65 72 65 73 74 20 |e same i|nterest |
|00000500| 72 61 74 65 3f 0a 0a 25 | 52 25 4c 75 6d 70 20 53 |rate?..%|R%Lump S|
|00000510| 75 6d 0a 0a 25 56 25 25 | 52 25 31 30 30 30 0a 0a |um..%V%%|R%1000..|
|00000520| 25 52 25 56 61 6c 75 65 | 0a 0a 25 56 25 25 52 25 |%R%Value|..%V%%R%|
|00000530| 41 32 31 2b 28 41 32 31 | 2a 28 42 32 31 2f 31 30 |A21+(A21|*(B21/10|
|00000540| 30 29 29 0a 25 56 25 25 | 52 25 41 32 35 2b 28 41 |0)).%V%%|R%A25+(A|
|00000550| 32 35 2a 28 42 24 32 31 | 2f 31 30 30 29 29 0a 25 |25*(B$21|/100)).%|
|00000560| 56 25 25 52 25 41 32 36 | 2b 28 41 32 36 2a 28 42 |V%%R%A26|+(A26*(B|
|00000570| 24 32 31 2f 31 30 30 29 | 29 0a 25 56 25 25 52 25 |$21/100)|).%V%%R%|
|00000580| 41 32 37 2b 28 41 32 37 | 2a 28 42 24 32 31 2f 31 |A27+(A27|*(B$21/1|
|00000590| 30 30 29 29 0a 25 56 25 | 25 52 25 41 32 38 2b 28 |00)).%V%|%R%A28+(|
|000005a0| 41 32 38 2a 28 42 24 32 | 31 2f 31 30 30 29 29 0a |A28*(B$2|1/100)).|
|000005b0| 25 56 25 25 52 25 41 32 | 39 2b 28 41 32 39 2a 28 |%V%%R%A2|9+(A29*(|
|000005c0| 42 24 32 31 2f 31 30 30 | 29 29 0a 25 56 25 25 52 |B$21/100|)).%V%%R|
|000005d0| 25 41 33 30 2b 28 41 33 | 30 2a 28 42 24 32 31 2f |%A30+(A3|0*(B$21/|
|000005e0| 31 30 30 29 29 0a 25 56 | 25 25 52 25 41 33 31 2b |100)).%V|%%R%A31+|
|000005f0| 28 41 33 31 2a 28 42 24 | 32 31 2f 31 30 30 29 29 |(A31*(B$|21/100))|
|00000600| 0a 25 56 25 25 52 25 41 | 33 32 2b 28 41 33 32 2a |.%V%%R%A|32+(A32*|
|00000610| 28 42 24 32 31 2f 31 30 | 30 29 29 0a 25 56 25 25 |(B$21/10|0)).%V%%|
|00000620| 52 25 41 33 33 2b 28 41 | 33 33 2a 28 42 24 32 31 |R%A33+(A|33*(B$21|
|00000630| 2f 31 30 30 29 29 0a 25 | 43 4f 3a 42 2c 31 32 2c |/100)).%|CO:B,12,|
|00000640| 36 30 25 0a 0a 0a 4e 42 | 20 20 45 6e 74 65 72 20 |60%...NB|  Enter |
|00000650| 64 61 74 61 20 6f 6e 6c | 79 20 69 6e 20 22 50 72 |data onl|y in "Pr|
|00000660| 69 6e 63 69 70 61 6c 22 | 2c 20 22 52 61 74 65 22 |incipal"|, "Rate"|
|00000670| 20 0a 20 20 20 20 61 6e | 64 20 22 54 65 72 6d 22 | .    an|d "Term"|
|00000680| 20 62 6f 78 65 73 0a 0a | 25 52 25 52 61 74 65 0a | boxes..|%R%Rate.|
|00000690| 25 56 25 25 52 25 31 30 | 0a 25 52 25 52 65 70 61 |%V%%R%10|.%R%Repa|
|000006a0| 79 6d 65 6e 74 0a 25 56 | 25 25 52 25 69 66 28 6c |yment.%V|%%R%if(l|
|000006b0| 6f 6f 70 63 3d 31 2c 45 | 38 2c 46 31 32 2b 28 46 |oopc=1,E|8,F12+(F|
|000006c0| 31 30 2f 31 30 30 29 29 | 0a 25 52 25 50 61 69 64 |10/100))|.%R%Paid|
|000006d0| 0a 25 56 25 25 52 25 28 | 42 31 30 2a 31 32 29 2a |.%V%%R%(|B10*12)*|
|000006e0| 43 38 0a 0a 0a 0a 0a 0a | 0a 25 52 25 52 61 74 65 |C8......|.%R%Rate|
|000006f0| 0a 0a 25 56 25 25 52 25 | 31 30 0a 0a a0 a0 0a 25 |..%V%%R%|10.....%|
|00000700| 43 4f 3a 43 2c 31 32 2c | 34 38 25 0a 0a 0a 0a 0a |CO:C,12,|48%.....|
|00000710| 0a 25 52 25 54 65 72 6d | 20 0a 25 56 25 25 52 25 |.%R%Term| .%V%%R%|
|00000720| 25 44 30 25 33 0a 25 52 | 25 56 61 6c 75 65 0a 25 |%D0%3.%R|%Value.%|
|00000730| 56 25 25 52 25 66 76 28 | 28 42 31 30 29 2a 31 32 |V%%R%fv(|(B10)*12|
|00000740| 2c 42 38 2f 31 30 30 2c | 43 38 29 0a 25 52 25 53 |,B8/100,|C8).%R%S|
|00000750| 61 76 69 6e 67 0a 25 56 | 25 25 52 25 43 31 30 2d |aving.%V|%%R%C10-|
|00000760| 42 31 32 0a 25 52 25 49 | 6e 74 65 72 65 73 74 0a |B12.%R%I|nterest.|
|00000770| 25 56 25 25 52 25 72 61 | 74 65 28 42 31 32 2c 41 |%V%%R%ra|te(B12,A|
|00000780| 38 2c 43 38 2a 31 32 29 | 2a 31 32 30 30 0a 0a 0a |8,C8*12)|*1200...|
|00000790| 0a 0a 25 52 25 4d 6f 6e | 74 68 6c 79 0a 0a 25 56 |..%R%Mon|thly..%V|
|000007a0| 25 25 52 25 32 35 0a 0a | 25 52 25 56 61 6c 75 65 |%%R%25..|%R%Value|
|000007b0| 0a 0a 0a 25 56 25 25 52 | 25 66 76 28 43 24 32 31 |...%V%%R|%fv(C$21|
|000007c0| 2a 31 32 2c 42 24 32 31 | 2f 31 30 30 2c 44 32 36 |*12,B$21|/100,D26|
|000007d0| 29 0a 25 56 25 25 52 25 | 66 76 28 43 24 32 31 2a |).%V%%R%|fv(C$21*|
|000007e0| 31 32 2c 42 24 32 31 2f | 31 30 30 2c 44 32 37 29 |12,B$21/|100,D27)|
|000007f0| 0a 25 56 25 25 52 25 66 | 76 28 43 24 32 31 2a 31 |.%V%%R%f|v(C$21*1|
|00000800| 32 2c 42 24 32 31 2f 31 | 30 30 2c 44 32 38 29 0a |2,B$21/1|00,D28).|
|00000810| 25 56 25 25 52 25 66 76 | 28 43 24 32 31 2a 31 32 |%V%%R%fv|(C$21*12|
|00000820| 2c 42 24 32 31 2f 31 30 | 30 2c 44 32 39 29 0a 25 |,B$21/10|0,D29).%|
|00000830| 56 25 25 52 25 66 76 28 | 43 24 32 31 2a 31 32 2c |V%%R%fv(|C$21*12,|
|00000840| 42 24 32 31 2f 31 30 30 | 2c 44 33 30 29 0a 25 56 |B$21/100|,D30).%V|
|00000850| 25 25 52 25 66 76 28 43 | 24 32 31 2a 31 32 2c 42 |%%R%fv(C|$21*12,B|
|00000860| 24 32 31 2f 31 30 30 2c | 44 33 31 29 0a 25 56 25 |$21/100,|D31).%V%|
|00000870| 25 52 25 66 76 28 43 24 | 32 31 2a 31 32 2c 42 24 |%R%fv(C$|21*12,B$|
|00000880| 32 31 2f 31 30 30 2c 44 | 33 32 29 0a 25 56 25 25 |21/100,D|32).%V%%|
|00000890| 52 25 66 76 28 43 24 32 | 31 2a 31 32 2c 42 24 32 |R%fv(C$2|1*12,B$2|
|000008a0| 31 2f 31 30 30 2c 44 33 | 33 29 0a 25 56 25 25 52 |1/100,D3|3).%V%%R|
|000008b0| 25 66 76 28 43 24 32 31 | 2a 31 32 2c 42 24 32 31 |%fv(C$21|*12,B$21|
|000008c0| 2f 31 30 30 2c 44 33 34 | 29 0a 25 43 4f 3a 44 2c |/100,D34|).%CO:D,|
|000008d0| 31 32 2c 33 36 25 0a 0a | 0a 0a 0a 0a a0 a0 0a 59 |12,36%..|.......Y|
|000008e0| 72 73 20 20 0a a0 a0 0a | 0a a0 a0 0a 0a a0 0a 0a |rs  ....|........|
|000008f0| 0a 0a 0a 0a a0 a0 0a 0a | 0a 0a 25 52 25 59 65 61 |........|..%R%Yea|
|00000900| 72 0a 0a 25 56 25 25 52 | 25 31 0a 25 56 25 25 52 |r..%V%%R|%1.%V%%R|
|00000910| 25 44 32 35 2b 31 0a 25 | 56 25 25 52 25 44 32 36 |%D25+1.%|V%%R%D26|
|00000920| 2b 31 0a 25 56 25 25 52 | 25 44 32 37 2b 31 0a 25 |+1.%V%%R|%D27+1.%|
|00000930| 56 25 25 52 25 44 32 38 | 2b 31 0a 25 56 25 25 52 |V%%R%D28|+1.%V%%R|
|00000940| 25 44 32 39 2b 31 0a 25 | 56 25 25 52 25 44 33 30 |%D29+1.%|V%%R%D30|
|00000950| 2b 31 0a 25 56 25 25 52 | 25 44 33 31 2b 31 0a 25 |+1.%V%%R|%D31+1.%|
|00000960| 56 25 25 52 25 44 33 32 | 2b 31 0a 25 56 25 25 52 |V%%R%D32|+1.%V%%R|
|00000970| 25 44 33 33 2b 31 0a 25 | 43 4f 3a 45 2c 31 32 2c |%D33+1.%|CO:E,12,|
|00000980| 32 34 25 0a 0a 0a 0a 0a | 0a 25 52 25 47 75 65 73 |24%.....|.%R%Gues|
|00000990| 73 0a 25 56 25 25 52 25 | 28 28 41 38 2b 28 28 41 |s.%V%%R%|((A8+((A|
|000009a0| 38 2a 42 38 2a 43 38 29 | 2f 31 30 30 29 29 2f 28 |8*B8*C8)|/100))/(|
|000009b0| 43 38 2a 31 32 29 29 2a | 30 2e 39 34 0a 25 52 25 |C8*12))*|0.94.%R%|
|000009c0| 56 61 72 69 61 6e 63 65 | 0a 25 56 25 25 52 25 41 |Variance|.%V%%R%A|
|000009d0| 31 30 2d 43 31 30 0a 25 | 52 25 4c 6f 6f 70 20 4e |10-C10.%|R%Loop N|
|000009e0| 6f 0a 25 56 25 25 52 25 | 6c 6f 6f 70 63 0a 0a 0a |o.%V%%R%|loopc...|
|000009f0| 0a 0a 0a 0a 0a 0a 0a 0a | a0 a0 0a 25 43 4f 3a 46 |........|...%CO:F|
|00000a00| 2c 31 32 2c 31 32 25 0a | 0a 0a 0a 0a 0a a0 0a 25 |,12,12%.|.......%|
|00000a10| 56 25 25 52 25 41 38 2b | 28 28 41 38 2a 42 38 2a |V%%R%A8+|((A8*B8*|
|00000a20| 43 38 29 2f 31 30 30 29 | 0a a0 0a 25 56 25 25 52 |C8)/100)|...%V%%R|
|00000a30| 25 73 67 6e 28 45 31 30 | 29 0a a0 0a 25 56 25 25 |%sgn(E10|)...%V%%|
|00000a40| 52 25 42 31 30 0a 25 43 | 4f 3a 47 2c 31 32 2c 30 |R%B10.%C|O:G,12,0|
|00000a50| 25 25 43 4f 3a 48 2c 31 | 32 2c 30 25 25 43 4f 3a |%%CO:H,1|2,0%%CO:|
|00000a60| 49 2c 31 32 2c 34 25 25 | 43 4f 3a 4a 2c 31 32 2c |I,12,4%%|CO:J,12,|
|00000a70| 30 25 25 43 4f 3a 4b 2c | 31 32 2c 30 25 25 43 4f |0%%CO:K,|12,0%%CO|
|00000a80| 3a 4c 2c 31 32 2c 30 25 | 25 43 4f 3a 4d 2c 31 32 |:L,12,0%|%CO:M,12|
|00000a90| 2c 30 25 25 43 4f 3a 4e | 2c 31 32 2c 30 25 25 43 |,0%%CO:N|,12,0%%C|
|00000aa0| 4f 3a 4f 2c 31 32 2c 30 | 25 25 43 4f 3a 50 2c 31 |O:O,12,0|%%CO:P,1|
|00000ab0| 32 2c 30 25 46 69 6c 65 | 44 61 74 61 82 52 65 61 |2,0%File|Data.Rea|
|00000ac0| 64 4d 65 00 ee 00 00 00 | 45 0f 00 00 42 de fd ff |dMe.....|E...B...|
|00000ad0| dc 33 01 f5 03 00 05 00 | 25 4f 50 25 4a 55 4e 0a |.3......|%OP%JUN.|
|00000ae0| 25 4f 50 25 44 50 30 0a | 25 4f 50 25 44 46 54 0a |%OP%DP0.|%OP%DFT.|
|00000af0| 25 4f 50 25 50 4c 30 0a | 25 4f 50 25 48 4d 30 0a |%OP%PL0.|%OP%HM0.|
|00000b00| 25 4f 50 25 46 4d 30 0a | 25 4f 50 25 42 4d 30 0a |%OP%FM0.|%OP%BM0.|
|00000b10| 25 4f 50 25 4c 4d 34 0a | 25 4f 50 25 52 49 59 0a |%OP%LM4.|%OP%RIY.|
|00000b20| 25 43 4f 3a 41 2c 37 32 | 2c 37 32 25 0a 25 43 25 |%CO:A,72|,72%.%C%|
|00000b30| 4c 75 6d 70 20 53 75 6d | 73 20 26 20 4d 6f 6e 74 |Lump Sum|s & Mont|
|00000b40| 68 6c 79 20 50 61 79 6d | 65 6e 74 73 0a 25 43 25 |hly Paym|ents.%C%|
|00000b50| 62 79 20 4d 61 6c 63 6f | 6c 6d 20 42 72 6f 77 6e |by Malco|lm Brown|
|00000b60| 0a 0a 5b 4e 6f 74 65 20 | 66 72 6f 6d 20 47 65 72 |..[Note |from Ger|
|00000b70| 61 6c 64 20 4c 20 46 69 | 74 74 6f 6e 3a 20 50 69 |ald L Fi|tton: Pi|
|00000b80| 70 65 44 72 65 61 6d 20 | 64 6f 65 73 20 68 61 76 |peDream |does hav|
|00000b90| 65 20 66 69 6e 61 6e 63 | 69 61 6c 20 66 75 6e 63 |e financ|ial func|
|00000ba0| 74 69 6f 6e 73 20 0a 28 | 68 61 76 65 20 61 20 6c |tions .(|have a l|
|00000bb0| 6f 6f 6b 20 61 74 20 70 | 61 67 65 73 20 31 35 37 |ook at p|ages 157|
|00000bc0| 20 74 6f 20 31 36 30 20 | 6f 66 20 74 68 65 20 75 | to 160 |of the u|
|00000bd0| 73 65 72 20 67 75 69 64 | 65 29 20 77 68 69 63 68 |ser guid|e) which|
|00000be0| 20 63 6f 75 6c 64 20 68 | 61 76 65 20 0a 62 65 65 | could h|ave .bee|
|00000bf0| 6e 20 75 73 65 64 20 74 | 6f 20 73 6f 6c 76 65 20 |n used t|o solve |
|00000c00| 4d 61 6c 63 6f 6c 6d 27 | 73 20 70 72 6f 62 6c 65 |Malcolm'|s proble|
|00000c10| 6d 20 6d 6f 72 65 20 65 | 6c 65 67 61 6e 74 6c 79 |m more e|legantly|
|00000c20| 2e 20 20 48 6f 77 65 76 | 65 72 2c 20 49 20 68 61 |.  Howev|er, I ha|
|00000c30| 76 65 20 0a 69 6e 63 6c | 75 64 65 64 20 68 69 73 |ve .incl|uded his|
|00000c40| 20 63 6f 6e 74 72 69 62 | 75 74 69 6f 6e 20 62 65 | contrib|ution be|
|00000c50| 63 61 75 73 65 20 49 20 | 62 65 6c 69 65 76 65 20 |cause I |believe |
|00000c60| 69 74 20 74 6f 20 62 65 | 20 61 6e 20 65 78 61 6d |it to be| an exam|
|00000c70| 70 6c 65 20 6f 66 20 74 | 68 65 20 0a 75 73 65 20 |ple of t|he .use |
|00000c80| 6f 66 20 50 69 70 65 44 | 72 65 61 6d 27 73 20 69 |of PipeD|ream's i|
|00000c90| 74 65 72 61 74 69 6f 6e | 20 66 61 63 69 6c 69 74 |teration| facilit|
|00000ca0| 79 20 77 68 69 63 68 20 | 69 73 20 6e 65 69 74 68 |y which |is neith|
|00000cb0| 65 72 20 74 6f 6f 20 73 | 69 6d 70 6c 65 20 74 6f |er too s|imple to|
|00000cc0| 20 62 65 20 0a 75 73 65 | 66 75 6c 20 6e 6f 72 20 | be .use|ful nor |
|00000cd0| 74 6f 6f 20 64 69 66 66 | 69 63 75 6c 74 20 74 6f |too diff|icult to|
|00000ce0| 20 75 6e 64 65 72 73 74 | 61 6e 64 20 77 68 61 74 | underst|and what|
|00000cf0| 20 69 73 20 68 61 70 70 | 65 6e 69 6e 67 2e 20 20 | is happ|ening.  |
|00000d00| 47 65 6e 65 72 61 6c 6c | 79 2c 20 0a 6d 61 74 68 |Generall|y, .math|
|00000d10| 65 6d 61 74 69 63 69 61 | 6e 73 20 75 73 65 20 69 |ematicia|ns use i|
|00000d20| 74 65 72 61 74 69 6f 6e | 20 6f 6e 6c 79 20 69 66 |teration| only if|
|00000d30| 20 61 20 66 6f 72 6d 75 | 6c 61 20 63 6f 6e 74 61 | a formu|la conta|
|00000d40| 69 6e 73 20 74 68 65 20 | 77 61 6e 74 65 64 20 0a |ins the |wanted .|
|00000d50| 76 61 72 69 61 62 6c 65 | 20 27 69 6d 70 6c 69 63 |variable| 'implic|
|00000d60| 69 74 6c 79 27 20 69 6e | 20 73 75 63 68 20 61 20 |itly' in| such a |
|00000d70| 77 61 79 20 74 68 61 74 | 20 74 68 65 20 66 6f 72 |way that| the for|
|00000d80| 6d 75 6c 61 20 63 61 6e | 20 6e 6f 74 20 62 65 20 |mula can| not be |
|00000d90| 0a 27 69 6e 76 65 72 74 | 65 64 27 20 28 73 6f 6c |.'invert|ed' (sol|
|00000da0| 76 65 64 29 20 74 6f 20 | 6f 62 74 61 69 6e 20 61 |ved) to |obtain a|
|00000db0| 6e 20 27 65 78 70 6c 69 | 63 69 74 27 20 73 6f 6c |n 'expli|cit' sol|
|00000dc0| 75 74 69 6f 6e 20 66 6f | 72 20 74 68 65 20 77 61 |ution fo|r the wa|
|00000dd0| 6e 74 65 64 20 0a 76 61 | 72 69 61 62 6c 65 2e 20 |nted .va|riable. |
|00000de0| 20 51 75 61 64 72 61 74 | 69 63 20 65 71 75 61 74 | Quadrat|ic equat|
|00000df0| 69 6f 6e 73 20 63 61 6e | 20 62 65 20 73 6f 6c 76 |ions can| be solv|
|00000e00| 65 64 20 27 65 78 70 6c | 69 63 69 74 6c 79 27 20 |ed 'expl|icitly' |
|00000e10| 62 75 74 20 71 75 69 6e | 74 69 63 73 20 0a 63 61 |but quin|tics .ca|
|00000e20| 6e 20 6e 6f 74 2e 20 20 | 49 66 20 79 6f 75 20 73 |n not.  |If you s|
|00000e30| 65 6e 64 20 6d 65 20 61 | 20 73 6f 6c 75 74 69 6f |end me a| solutio|
|00000e40| 6e 20 74 6f 20 4d 61 6c | 63 6f 6c 6d 27 73 20 27 |n to Mal|colm's '|
|00000e50| 41 6d 6f 72 74 69 73 61 | 74 69 6f 6e 20 41 6e 6e |Amortisa|tion Ann|
|00000e60| 75 69 74 79 27 20 0a 70 | 72 6f 62 6c 65 6d 20 75 |uity' .p|roblem u|
|00000e70| 73 69 6e 67 20 50 69 70 | 65 44 72 65 61 6d 27 73 |sing Pip|eDream's|
|00000e80| 20 62 75 69 6c 74 20 69 | 6e 20 66 69 6e 61 6e 63 | built i|n financ|
|00000e90| 69 61 6c 20 66 75 6e 63 | 74 69 6f 6e 73 20 74 68 |ial func|tions th|
|00000ea0| 65 6e 20 49 20 77 69 6c | 6c 20 0a 69 6e 63 6c 75 |en I wil|l .inclu|
|00000eb0| 64 65 20 69 6e 20 6f 6e | 20 6f 6e 65 20 6f 66 20 |de in on| one of |
|00000ec0| 74 68 65 20 71 75 61 72 | 74 65 72 6c 79 20 50 69 |the quar|terly Pi|
|00000ed0| 70 65 4c 69 6e 65 20 64 | 69 73 63 73 2e 20 20 41 |peLine d|iscs.  A|
|00000ee0| 20 27 52 65 70 61 79 6d | 65 6e 74 20 0a 53 63 68 | 'Repaym|ent .Sch|
|00000ef0| 65 64 75 6c 65 27 20 28 | 73 68 6f 77 69 6e 67 20 |edule' (|showing |
|00000f00| 6a 75 73 74 20 68 6f 77 | 20 6d 75 63 68 20 69 73 |just how| much is|
|00000f10| 20 73 74 69 6c 6c 20 6f | 77 65 64 20 61 74 20 61 | still o|wed at a|
|00000f20| 6e 79 20 74 69 6d 65 29 | 20 63 6f 75 6c 64 20 62 |ny time)| could b|
|00000f30| 65 20 0a 75 73 65 66 75 | 6c 20 66 6f 72 20 77 6f |e .usefu|l for wo|
|00000f40| 72 6b 69 6e 67 20 6f 75 | 74 20 75 6e 66 69 6e 69 |rking ou|t unfini|
|00000f50| 73 68 65 64 20 27 48 69 | 72 65 20 50 75 72 63 68 |shed 'Hi|re Purch|
|00000f60| 61 73 65 27 20 63 61 6c | 63 75 6c 61 74 69 6f 6e |ase' cal|culation|
|00000f70| 73 2e 20 2d 20 47 4c 46 | 5d 0a 0a 49 74 20 72 65 |s. - GLF|]..It re|
|00000f80| 63 65 6e 74 6c 79 20 6f | 63 63 75 72 65 64 20 74 |cently o|ccured t|
|00000f90| 68 61 74 20 74 77 6f 20 | 72 65 6c 61 74 65 64 20 |hat two |related |
|00000fa0| 70 72 6f 62 6c 65 6d 73 | 20 70 72 65 73 65 6e 74 |problems| present|
|00000fb0| 65 64 20 74 68 65 6d 73 | 65 6c 76 65 73 20 0a 77 |ed thems|elves .w|
|00000fc0| 68 69 63 68 20 6d 61 79 | 20 72 65 61 70 70 65 61 |hich may| reappea|
|00000fd0| 72 20 61 6e 64 20 73 6f | 20 61 20 63 6f 6d 70 75 |r and so| a compu|
|00000fe0| 74 65 72 20 73 6f 6c 75 | 74 69 6f 6e 20 73 65 65 |ter solu|tion see|
|00000ff0| 6d 65 64 20 77 6f 72 74 | 68 77 68 69 6c 65 2e 20 |med wort|hwhile. |
|00001000| 20 41 20 0a 66 61 6d 69 | 6c 79 20 6d 65 6d 62 65 | A .fami|ly membe|
|00001010| 72 20 77 61 73 20 69 6e | 20 6e 65 65 64 20 6f 66 |r was in| need of|
|00001020| 20 61 20 6c 6f 61 6e 20 | 61 6e 64 20 6d 6f 6e 65 | a loan |and mone|
|00001030| 79 20 77 61 73 20 61 76 | 61 69 6c 61 62 6c 65 2e |y was av|ailable.|
|00001040| 20 20 49 74 20 73 65 65 | 6d 65 64 20 0a 73 65 6e |  It see|med .sen|
|00001050| 73 69 62 6c 65 20 74 6f | 20 6d 61 6b 65 20 74 68 |sible to| make th|
|00001060| 65 20 6c 6f 61 6e 20 74 | 68 72 6f 75 67 68 20 74 |e loan t|hrough t|
|00001070| 68 65 20 66 61 6d 69 6c | 79 2e 20 42 75 74 2e 2e |he famil|y. But..|
|00001080| 2e 0a 0a 54 68 65 20 73 | 75 6d 2c 20 69 66 20 69 |...The s|um, if i|
|00001090| 74 20 77 65 72 65 20 74 | 6f 20 72 65 6d 61 69 6e |t were t|o remain|
|000010a0| 20 69 6e 20 74 68 65 20 | 62 61 6e 6b 20 77 6f 75 | in the |bank wou|
|000010b0| 6c 64 20 61 74 74 72 61 | 63 74 20 69 6e 74 65 72 |ld attra|ct inter|
|000010c0| 65 73 74 2e 20 20 54 68 | 65 20 0a 6c 6f 61 6e 20 |est.  Th|e .loan |
|000010d0| 77 6f 75 6c 64 20 62 65 | 20 72 65 70 61 69 64 20 |would be| repaid |
|000010e0| 69 6e 20 6d 6f 6e 74 68 | 6c 79 20 69 6e 73 74 61 |in month|ly insta|
|000010f0| 6c 6d 65 6e 74 73 20 77 | 68 69 63 68 20 70 72 65 |lments w|hich pre|
|00001100| 73 75 6d 61 62 6c 79 20 | 77 6f 75 6c 64 20 6e 6f |sumably |would no|
|00001110| 74 20 0a 61 63 72 75 65 | 20 73 6f 20 6d 75 63 68 |t .acrue| so much|
|00001120| 20 69 6e 74 65 72 65 73 | 74 2e 20 20 57 65 20 73 | interes|t.  We s|
|00001130| 69 6d 70 6c 79 20 77 61 | 6e 74 65 64 20 74 6f 20 |imply wa|nted to |
|00001140| 62 72 65 61 6b 20 65 76 | 65 6e 20 2d 20 61 73 73 |break ev|en - ass|
|00001150| 75 6d 69 6e 67 20 61 20 | 0a 73 74 61 74 69 63 20 |uming a |.static |
|00001160| 69 6e 74 65 72 65 73 74 | 20 72 61 74 65 2e 0a 0a |interest| rate...|
|00001170| 54 68 65 20 72 65 71 75 | 69 72 65 6d 65 6e 74 2c |The requ|irement,|
|00001180| 20 74 68 65 72 65 66 6f | 72 65 2c 20 77 61 73 20 | therefo|re, was |
|00001190| 73 69 6d 70 6c 79 20 74 | 6f 20 63 61 6c 63 75 6c |simply t|o calcul|
|000011a0| 61 74 65 20 77 68 61 74 | 20 6d 6f 6e 74 68 6c 79 |ate what| monthly|
|000011b0| 20 0a 72 65 70 61 79 6d | 65 6e 74 20 77 6f 75 6c | .repaym|ent woul|
|000011c0| 64 20 62 65 20 72 65 71 | 75 69 72 65 64 20 74 6f |d be req|uired to|
|000011d0| 20 6d 61 74 63 68 20 74 | 68 65 20 28 70 72 69 6e | match t|he (prin|
|000011e0| 63 69 70 6c 65 20 2b 20 | 69 6e 74 65 72 65 73 74 |ciple + |interest|
|000011f0| 29 20 61 74 20 74 68 65 | 20 0a 65 6e 64 20 6f 66 |) at the| .end of|
|00001200| 20 74 68 65 20 74 65 72 | 6d 2e 20 20 5b 54 68 69 | the ter|m.  [Thi|
|00001210| 73 20 69 73 20 74 68 65 | 20 63 6c 61 73 73 69 63 |s is the| classic|
|00001220| 20 27 41 6d 6f 72 74 69 | 73 61 74 69 6f 6e 20 41 | 'Amorti|sation A|
|00001230| 6e 6e 75 69 74 79 27 20 | 70 72 6f 62 6c 65 6d 20 |nnuity' |problem |
|00001240| 2d 20 0a 48 61 76 65 20 | 79 6f 75 20 61 6e 20 65 |- .Have |you an e|
|00001250| 6c 65 67 61 6e 74 20 73 | 6f 6c 75 74 69 6f 6e 20 |legant s|olution |
|00001260| 66 6f 72 20 70 75 62 6c | 69 63 61 74 69 6f 6e 3f |for publ|ication?|
|00001270| 20 2d 20 47 4c 46 5d 0a | 0a 54 68 65 20 66 69 72 | - GLF].|.The fir|
|00001280| 73 74 20 70 72 6f 62 6c | 65 6d 20 77 61 73 20 74 |st probl|em was t|
|00001290| 6f 20 63 61 6c 63 75 6c | 61 74 65 20 74 68 65 20 |o calcul|ate the |
|000012a0| 63 6f 6d 70 6f 75 6e 64 | 20 69 6e 74 65 72 65 73 |compound| interes|
|000012b0| 74 20 28 41 31 30 20 6f | 6e 20 74 68 65 20 0a 6c |t (A10 o|n the .l|
|000012c0| 6f 61 6e 20 66 69 6c 65 | 29 2e 20 20 57 68 79 20 |oan file|).  Why |
|000012d0| 64 6f 6e 27 74 20 73 70 | 72 65 61 64 73 68 65 65 |don't sp|readshee|
|000012e0| 74 73 20 68 61 76 65 20 | 61 20 62 75 69 6c 74 20 |ts have |a built |
|000012f0| 69 6e 20 66 75 6e 63 74 | 69 6f 6e 20 66 6f 72 20 |in funct|ion for |
|00001300| 74 68 69 73 20 0a 66 6f | 72 6d 75 6c 61 3f 20 20 |this .fo|rmula?  |
|00001310| 49 20 72 65 6d 65 6d 62 | 65 72 20 63 61 6c 63 75 |I rememb|er calcu|
|00001320| 6c 61 74 69 6e 67 20 74 | 68 69 73 20 61 74 20 73 |lating t|his at s|
|00001330| 63 68 6f 6f 6c 20 33 30 | 20 79 65 61 72 73 20 61 |chool 30| years a|
|00001340| 67 6f 20 62 75 74 20 49 | 20 0a 63 6f 75 6c 64 20 |go but I| .could |
|00001350| 6e 6f 74 20 72 65 6d 65 | 6d 62 65 72 20 74 68 65 |not reme|mber the|
|00001360| 20 66 6f 72 6d 75 6c 61 | 20 61 6e 64 20 69 74 20 | formula| and it |
|00001370| 74 6f 6f 6b 20 73 6f 6d | 65 20 70 72 69 73 69 6e |took som|e prisin|
|00001380| 67 20 6f 75 74 20 6f 66 | 20 74 68 65 20 0a 6c 6f |g out of| the .lo|
|00001390| 63 61 6c 20 6c 69 62 72 | 61 72 79 2e 20 0a 0a 54 |cal libr|ary. ..T|
|000013a0| 68 65 20 73 65 63 6f 6e | 64 20 77 61 73 20 68 6f |he secon|d was ho|
|000013b0| 77 20 74 6f 20 63 61 6c | 63 75 6c 61 74 65 20 74 |w to cal|culate t|
|000013c0| 68 65 20 6d 6f 6e 74 68 | 6c 79 20 72 65 70 61 79 |he month|ly repay|
|000013d0| 6d 65 6e 74 20 28 42 31 | 30 29 20 73 6f 20 74 68 |ment (B1|0) so th|
|000013e0| 61 74 20 74 68 65 20 0a | 76 61 6c 75 65 20 28 43 |at the .|value (C|
|000013f0| 31 30 29 20 65 71 75 61 | 6c 65 64 20 74 68 65 20 |10) equa|led the |
|00001400| 72 65 74 75 72 6e 20 28 | 41 31 30 29 2e 20 20 53 |return (|A10).  S|
|00001410| 6f 20 74 68 61 74 20 61 | 74 20 74 68 65 20 65 6e |o that a|t the en|
|00001420| 64 20 6f 66 20 74 68 65 | 20 6c 6f 61 6e 20 0a 70 |d of the| loan .p|
|00001430| 65 72 69 6f 64 20 74 68 | 65 20 62 61 6e 6b 20 62 |eriod th|e bank b|
|00001440| 61 6c 61 6e 63 65 20 77 | 6f 75 6c 64 20 6c 6f 6f |alance w|ould loo|
|00001450| 6b 20 65 78 61 63 74 6c | 79 20 61 73 20 69 74 20 |k exactl|y as it |
|00001460| 77 6f 75 6c 64 20 68 61 | 76 65 20 64 6f 6e 65 20 |would ha|ve done |
|00001470| 69 66 20 0a 6e 6f 74 68 | 69 6e 67 20 68 61 64 20 |if .noth|ing had |
|00001480| 68 61 70 70 65 6e 65 64 | 2e 20 20 57 68 61 74 20 |happened|.  What |
|00001490| 61 20 66 72 75 73 74 72 | 61 74 69 6f 6e 21 20 20 |a frustr|ation!  |
|000014a0| 49 74 65 72 61 74 69 6f | 6e 20 69 73 20 6e 6f 74 |Iteratio|n is not|
|000014b0| 20 74 68 65 20 0a 65 61 | 73 69 65 73 74 20 70 72 | the .ea|siest pr|
|000014c0| 6f 63 65 73 73 20 74 6f | 20 67 65 74 20 72 69 67 |ocess to| get rig|
|000014d0| 68 74 20 2d 20 74 68 65 | 20 74 68 69 6e 67 20 77 |ht - the| thing w|
|000014e0| 6f 75 6c 64 20 6e 6f 74 | 20 6d 6f 76 65 20 61 74 |ould not| move at|
|000014f0| 20 61 6c 6c 20 6f 72 20 | 0a 64 69 76 65 72 67 65 | all or |.diverge|
|00001500| 64 20 76 69 6f 6c 65 6e | 74 6c 79 2e 20 20 45 76 |d violen|tly.  Ev|
|00001510| 65 6e 74 75 61 6c 6c 79 | 20 49 20 61 62 61 6e 64 |entually| I aband|
|00001520| 6f 6e 65 64 20 61 6c 6c | 20 6d 79 20 70 72 69 6e |oned all| my prin|
|00001530| 63 69 70 6c 65 73 20 61 | 6e 64 20 72 65 61 64 20 |ciples a|nd read |
|00001540| 0a 74 68 65 20 6d 61 6e | 75 61 6c 2e 20 20 54 68 |.the man|ual.  Th|
|00001550| 65 72 65 20 69 74 20 77 | 61 73 20 2d 20 70 61 67 |ere it w|as - pag|
|00001560| 65 20 32 36 36 20 2d 20 | 74 68 65 20 73 6f 6c 76 |e 266 - |the solv|
|00001570| 69 6e 67 20 6f 66 20 73 | 69 6d 75 6c 74 61 6e 65 |ing of s|imultane|
|00001580| 6f 75 73 20 0a 65 71 75 | 61 74 69 6f 6e 73 2e 20 |ous .equ|ations. |
|00001590| 20 41 6e 64 20 73 6f 20 | 28 42 31 30 29 20 61 6e | And so |(B10) an|
|000015a0| 64 20 28 46 31 32 29 20 | 63 68 65 63 6b 20 65 61 |d (F12) |check ea|
|000015b0| 63 68 20 6f 74 68 65 72 | 20 75 6e 74 69 6c 20 74 |ch other| until t|
|000015c0| 68 65 79 20 63 6f 6d 65 | 20 74 6f 20 0a 73 6f 6d |hey come| to .som|
|000015d0| 65 20 61 6d 69 63 61 62 | 6c 65 20 61 72 72 61 6e |e amicab|le arran|
|000015e0| 67 65 6d 65 6e 74 2e 20 | 20 49 20 68 61 64 20 74 |gement. | I had t|
|000015f0| 6f 20 75 73 65 20 74 68 | 65 20 53 47 4e 20 28 46 |o use th|e SGN (F|
|00001600| 31 30 29 20 61 73 20 74 | 68 65 20 6d 6f 64 69 66 |10) as t|he modif|
|00001610| 69 65 72 3b 20 0a 6a 75 | 73 74 20 75 73 69 6e 67 |ier; .ju|st using|
|00001620| 20 74 68 65 20 27 56 61 | 72 69 61 6e 63 65 27 20 | the 'Va|riance' |
|00001630| 28 45 31 30 29 20 62 72 | 6f 75 67 68 74 20 76 69 |(E10) br|ought vi|
|00001640| 6f 6c 65 6e 74 20 66 6c | 75 63 74 75 61 74 69 6f |olent fl|uctuatio|
|00001650| 6e 73 2e 20 20 49 74 20 | 0a 77 6f 72 6b 65 64 2c |ns.  It |.worked,|
|00001660| 20 62 75 74 20 69 74 20 | 74 6f 6f 6b 20 68 6f 75 | but it |took hou|
|00001670| 72 73 2c 20 35 30 30 30 | 20 69 74 65 72 61 74 69 |rs, 5000| iterati|
|00001680| 6f 6e 73 2e 20 20 54 68 | 69 73 20 77 61 73 20 6e |ons.  Th|is was n|
|00001690| 6f 20 67 6f 6f 64 20 2d | 20 49 20 63 6f 75 6c 64 |o good -| I could|
|000016a0| 20 0a 64 6f 20 69 74 20 | 6f 6e 20 70 61 70 65 72 | .do it |on paper|
|000016b0| 20 71 75 69 63 6b 65 72 | 21 20 20 53 6f 6d 65 20 | quicker|!  Some |
|000016c0| 73 6f 72 74 20 6f 66 20 | 67 75 65 73 73 20 77 6f |sort of |guess wo|
|000016d0| 75 6c 64 20 68 61 76 65 | 20 74 6f 20 62 65 20 6d |uld have| to be m|
|000016e0| 61 64 65 2e 0a 0a 54 68 | 65 20 74 68 69 72 64 20 |ade...Th|e third |
|000016f0| 70 72 6f 62 6c 65 6d 20 | 77 61 73 20 77 68 61 74 |problem |was what|
|00001700| 20 66 69 67 75 72 65 20 | 74 6f 20 70 75 74 20 69 | figure |to put i|
|00001710| 6e 2e 20 20 45 76 65 6e | 74 75 61 6c 79 20 49 20 |n.  Even|tualy I |
|00001720| 73 65 74 74 6c 65 64 20 | 6f 6e 20 0a 63 61 6c 63 |settled |on .calc|
|00001730| 75 6c 61 74 69 6e 67 20 | 74 68 65 20 73 69 6d 70 |ulating |the simp|
|00001740| 6c 65 20 28 69 6e 74 65 | 72 65 73 74 20 2b 20 70 |le (inte|rest + p|
|00001750| 72 69 6e 63 69 70 6c 65 | 29 20 61 6e 64 20 64 69 |rinciple|) and di|
|00001760| 76 69 64 69 6e 67 20 62 | 79 20 74 68 65 20 74 65 |viding b|y the te|
|00001770| 72 6d 20 0a 69 6e 20 6d | 6f 6e 74 68 73 20 2d 20 |rm .in m|onths - |
|00001780| 28 45 38 29 2e 20 20 49 | 20 68 6f 70 65 20 74 68 |(E8).  I| hope th|
|00001790| 69 73 20 64 6f 65 73 20 | 6e 6f 74 20 72 65 76 65 |is does |not reve|
|000017a0| 61 6c 20 73 6f 6d 65 20 | 67 68 61 73 74 6c 79 20 |al some |ghastly |
|000017b0| 66 6c 61 77 20 62 75 74 | 20 0a 74 68 69 73 20 70 |flaw but| .this p|
|000017c0| 72 6f 76 65 64 20 74 6f | 6f 20 68 69 67 68 2c 20 |roved to|o high, |
|000017d0| 73 6f 20 74 68 65 20 77 | 68 6f 6c 65 20 74 68 69 |so the w|hole thi|
|000017e0| 6e 67 20 69 73 20 6d 75 | 6c 74 69 70 6c 69 65 64 |ng is mu|ltiplied|
|000017f0| 20 62 79 20 30 2e 39 34 | 20 74 6f 20 67 65 74 20 | by 0.94| to get |
|00001800| 61 20 0a 6e 65 61 72 20 | 67 75 65 73 73 20 66 6f |a .near |guess fo|
|00001810| 72 20 61 6c 6c 20 76 61 | 72 69 61 74 69 6f 6e 73 |r all va|riations|
|00001820| 2e 0a 0a 4f 75 74 20 6f | 66 20 69 6e 74 65 72 65 |...Out o|f intere|
|00001830| 73 74 20 2d 20 70 75 6e | 20 69 6e 74 65 6e 64 65 |st - pun| intende|
|00001840| 64 20 2d 20 74 68 65 20 | 61 6d 6f 75 6e 74 20 70 |d - the |amount p|
|00001850| 61 69 64 20 62 79 20 74 | 68 65 20 62 6f 72 72 6f |aid by t|he borro|
|00001860| 77 65 72 2c 20 74 68 65 | 69 72 20 0a 73 61 76 69 |wer, the|ir .savi|
|00001870| 6e 67 20 61 6e 64 20 69 | 6e 74 65 72 65 73 74 20 |ng and i|nterest |
|00001880| 70 61 69 64 20 69 73 20 | 61 6c 73 6f 20 63 61 6c |paid is |also cal|
|00001890| 63 75 6c 61 74 65 64 2e | 0a 0a 57 68 61 74 20 61 |culated.|..What a|
|000018a0| 20 6c 6f 74 20 6f 66 20 | 77 6f 72 64 73 20 66 6f | lot of |words fo|
|000018b0| 72 20 31 35 20 63 65 6c | 6c 73 20 6f 66 20 63 61 |r 15 cel|ls of ca|
|000018c0| 6c 63 75 6c 61 74 69 6f | 6e 2e 0a 0a 54 68 65 20 |lculatio|n...The |
|000018d0| 6c 75 6d 70 20 73 75 6d | 20 76 65 72 73 75 73 20 |lump sum| versus |
|000018e0| 6d 6f 6e 74 68 6c 79 20 | 70 61 79 6d 65 6e 74 73 |monthly |payments|
|000018f0| 20 63 61 6c 63 75 6c 61 | 74 69 6f 6e 20 6f 6e 6c | calcula|tion onl|
|00001900| 79 20 6e 65 65 64 65 64 | 20 61 6e 20 61 6e 73 77 |y needed| an answ|
|00001910| 65 72 20 0a 74 6f 20 74 | 68 65 20 6e 65 61 72 65 |er .to t|he neare|
|00001920| 73 74 20 79 65 61 72 20 | 61 6e 64 20 73 6f 20 64 |st year |and so d|
|00001930| 69 64 20 6e 6f 74 20 6e | 65 65 64 20 74 6f 20 62 |id not n|eed to b|
|00001940| 65 20 73 6f 20 73 6f 70 | 68 69 73 74 69 63 61 74 |e so sop|histicat|
|00001950| 65 64 2e 20 20 49 74 20 | 0a 63 6f 75 6c 64 20 62 |ed.  It |.could b|
|00001960| 65 20 6d 61 64 65 20 6d | 6f 72 65 20 73 6f 70 68 |e made m|ore soph|
|00001970| 69 73 74 61 63 65 64 20 | 62 79 20 63 6f 6d 70 75 |istaced |by compu|
|00001980| 74 69 6e 67 20 74 68 65 | 20 61 63 74 75 61 6c 20 |ting the| actual |
|00001990| 62 72 65 61 6b 2d 65 76 | 65 6e 20 0a 66 69 67 75 |break-ev|en .figu|
|000019a0| 72 65 20 61 6e 64 20 74 | 68 65 6e 20 63 61 6c 63 |re and t|hen calc|
|000019b0| 75 6c 61 74 69 6e 67 20 | 74 68 65 20 74 69 6d 65 |ulating |the time|
|000019c0| 2c 20 6f 72 2c 20 65 76 | 65 6e 20 62 65 74 74 65 |, or, ev|en bette|
|000019d0| 72 2c 20 65 78 70 6f 72 | 74 69 6e 67 20 69 74 20 |r, expor|ting it |
|000019e0| 74 6f 20 0a 50 72 65 73 | 65 6e 74 65 72 49 49 20 |to .Pres|enterII |
|000019f0| 28 77 68 69 63 68 20 49 | 20 68 61 76 65 6e 27 74 |(which I| haven't|
|00001a00| 20 67 6f 74 29 20 61 6e | 64 20 70 72 6f 64 75 63 | got) an|d produc|
|00001a10| 69 6e 67 20 61 20 67 72 | 61 70 68 2e 0a 46 69 6c |ing a gr|aph..Fil|
|00001a20| 65 44 61 74 61 82 6e 65 | 77 5f 73 68 65 65 74 00 |eData.ne|w_sheet.|
|00001a30| 00 f9 00 00 00 42 21 fd | ff 8d cc d2 ee 03 00 ef |.....B!.|........|
|00001a40| e8 5c 42 6e 65 77 7c 6d | 20 20 20 4e 65 77 20 77 |.\Bnew|m|   New w|
|00001a50| 69 6e 64 6f 77 0a 5c 4f | 7c 69 20 22 22 20 7c 69 |indow.\O||i "" |i|
|00001a60| 20 4e 20 7c 69 20 52 20 | 7c 69 20 59 20 7c 69 20 | N |i R ||i Y |i |
|00001a70| 4e 20 7c 69 20 4e 20 7c | 69 20 32 20 7c 69 20 4d |N |i N ||i 2 |i M|
|00001a80| 20 7c 69 20 22 6e 6f 6e | 65 22 20 7c 69 20 4e 20 | |i "non|e" |i N |
|00001a90| 7c 69 20 54 20 7c 69 20 | 22 a3 22 20 7c 69 20 22 ||i T |i |"." |i "|
|00001aa0| 25 22 20 7c 69 20 59 20 | 7c 6d 20 20 20 20 20 20 |%" |i Y ||m      |
|00001ab0| 20 20 4f 70 74 69 6f 6e | 73 0a 5c 42 72 65 7c 69 |  Option|s.\Bre|i|
|00001ac0| 20 22 61 31 22 20 7c 69 | 20 22 41 31 7a 31 22 20 | "a1" |i| "A1z1" |
|00001ad0| 7c 6d 20 20 20 20 20 20 | 20 20 52 65 70 6c 69 63 ||m      |  Replic|
|00001ae0| 61 74 65 0a 5c 48 7c 69 | 20 30 20 7c 69 20 22 62 |ate.\H|i| 0 |i "b|
|00001af0| 20 7a 22 20 7c 6d 20 20 | 20 20 20 20 20 20 53 65 | z" |m  |      Se|
|00001b00| 74 20 72 69 67 68 74 20 | 6d 61 72 67 69 6e 0a 5c |t right |margin.\|
|00001b10| 42 72 65 7c 69 20 22 61 | 31 22 20 7c 69 20 22 41 |Bre|i "a|1" |i "A|
|00001b20| 31 61 32 30 22 20 7c 6d | 20 20 20 20 20 20 20 20 |1a20" |m|        |
|00001b30| 52 65 70 6c 69 63 61 74 | 65 0a 46 69 6c 65 44 61 |Replicat|e.FileDa|
|00001b40| 74 61 82 6e 65 77 5f 77 | 6f 72 64 00 00 00 5c 01 |ta.new_w|ord...\.|
|00001b50| 00 00 42 21 fd ff 59 26 | d4 ee 03 00 45 bf 5c 42 |..B!..Y&|....E.\B|
|00001b60| 6e 65 77 7c 6d 20 20 20 | 4e 65 77 20 77 69 6e 64 |new|m   |New wind|
|00001b70| 6f 77 0a 5c 4f 7c 69 20 | 22 22 20 7c 69 20 54 20 |ow.\O|i |"" |i T |
|00001b80| 7c 69 20 52 20 7c 69 20 | 4e 20 7c 69 20 4e 20 7c ||i R |i |N |i N ||
|00001b90| 69 20 59 20 7c 69 20 32 | 20 7c 69 20 4d 20 7c 69 |i Y |i 2| |i M |i|
|00001ba0| 20 22 6e 6f 6e 65 22 20 | 7c 69 20 59 20 7c 69 20 | "none" ||i Y |i |
|00001bb0| 54 20 7c 69 20 22 a3 22 | 20 7c 69 20 22 25 22 20 |T |i "."| |i "%" |
|00001bc0| 7c 69 20 4e 20 7c 6d 20 | 20 20 20 20 20 20 20 4f ||i N |m |       O|
|00001bd0| 70 74 69 6f 6e 73 0a 5c | 57 7c 69 20 37 37 20 7c |ptions.\|W|i 77 ||
|00001be0| 69 20 22 41 22 20 7c 6d | 20 20 20 20 20 20 20 20 |i "A" |m|        |
|00001bf0| 53 65 74 20 63 6f 6c 75 | 6d 6e 20 77 69 64 74 68 |Set colu|mn width|
|00001c00| 0a 5c 48 7c 69 20 30 20 | 20 7c 69 20 22 41 22 20 |.\H|i 0 | |i "A" |
|00001c10| 7c 6d 20 20 20 20 20 20 | 20 20 53 65 74 20 72 69 ||m      |  Set ri|
|00001c20| 67 68 74 20 6d 61 72 67 | 69 6e 0a 5c 43 6e 63 7c |ght marg|in.\Cnc||
|00001c30| 6d 20 20 20 20 4e 65 78 | 74 20 63 6f 6c 75 6d 6e |m    Nex|t column|
|00001c40| 0a 5c 45 64 63 7c 6d 20 | 20 20 20 44 65 6c 65 74 |.\Edc|m |   Delet|
|00001c50| 65 20 63 6f 6c 75 6d 6e | 0a 5c 45 64 63 7c 6d 20 |e column|.\Edc|m |
|00001c60| 20 20 20 44 65 6c 65 74 | 65 20 63 6f 6c 75 6d 6e |   Delet|e column|
|00001c70| 0a 5c 45 64 63 7c 6d 20 | 20 20 20 44 65 6c 65 74 |.\Edc|m |   Delet|
|00001c80| 65 20 63 6f 6c 75 6d 6e | 0a 5c 45 64 63 7c 6d 20 |e column|.\Edc|m |
|00001c90| 20 20 20 44 65 6c 65 74 | 65 20 63 6f 6c 75 6d 6e |   Delet|e column|
|00001ca0| 0a 5c 45 64 63 7c 6d 20 | 20 20 20 44 65 6c 65 74 |.\Edc|m |   Delet|
|00001cb0| 65 20 63 6f 6c 75 6d 6e | 0a 0a 46 69 6c 65 44 61 |e column|..FileDa|
|00001cc0| 74 61 82 52 65 61 64 4d | 65 00 00 00 00 00 ea 08 |ta.ReadM|e.......|
|00001cd0| 00 00 42 de fd ff 61 0c | 06 f5 03 00 c2 dc 25 4f |..B...a.|......%O|
|00001ce0| 50 25 4a 55 4e 0a 25 4f | 50 25 44 50 30 0a 25 4f |P%JUN.%O|P%DP0.%O|
|00001cf0| 50 25 44 46 54 0a 25 4f | 50 25 50 4c 30 0a 25 4f |P%DFT.%O|P%PL0.%O|
|00001d00| 50 25 48 4d 30 0a 25 4f | 50 25 46 4d 30 0a 25 4f |P%HM0.%O|P%FM0.%O|
|00001d10| 50 25 42 4d 30 0a 25 4f | 50 25 4c 4d 34 0a 25 43 |P%BM0.%O|P%LM4.%C|
|00001d20| 4f 3a 41 2c 37 32 2c 37 | 32 25 0a 25 43 25 4e 65 |O:A,72,7|2%.%C%Ne|
|00001d30| 77 20 44 6f 63 75 6d 65 | 6e 74 73 0a 25 43 25 62 |w Docume|nts.%C%b|
|00001d40| 79 20 47 65 72 61 6c 64 | 20 4c 20 46 69 74 74 6f |y Gerald| L Fitto|
|00001d50| 6e 0a 25 43 25 55 73 69 | 6e 67 20 45 78 61 6d 70 |n.%C%Usi|ng Examp|
|00001d60| 6c 65 73 20 62 79 20 52 | 6f 62 65 72 74 20 4d 61 |les by R|obert Ma|
|00001d70| 63 6d 69 6c 6c 61 6e 0a | 0a 50 69 70 65 44 72 65 |cmillan.|.PipeDre|
|00001d80| 61 6d 20 69 73 20 61 20 | 77 6f 6e 64 65 72 66 75 |am is a |wonderfu|
|00001d90| 6c 6c 79 20 69 6e 74 65 | 67 72 61 74 65 64 20 70 |lly inte|grated p|
|00001da0| 61 63 6b 61 67 65 20 77 | 68 69 63 68 20 63 61 6e |ackage w|hich can|
|00001db0| 20 62 65 20 75 73 65 64 | 20 61 73 20 61 20 0a 77 | be used| as a .w|
|00001dc0| 6f 72 64 70 72 6f 63 65 | 73 73 6f 72 2c 20 73 70 |ordproce|ssor, sp|
|00001dd0| 72 65 61 64 73 68 65 65 | 74 20 61 6e 64 20 64 61 |readshee|t and da|
|00001de0| 74 61 62 61 73 65 20 61 | 6c 6c 20 77 69 74 68 69 |tabase a|ll withi|
|00001df0| 6e 20 74 68 65 20 73 61 | 6d 65 20 64 6f 63 75 6d |n the sa|me docum|
|00001e00| 65 6e 74 2e 20 20 0a 42 | 65 63 61 75 73 65 20 69 |ent.  .B|ecause i|
|00001e10| 74 20 63 61 6e 20 64 6f | 20 61 6c 6c 20 74 68 65 |t can do| all the|
|00001e20| 73 65 20 74 68 69 6e 67 | 73 20 61 74 20 6f 6e 63 |se thing|s at onc|
|00001e30| 65 20 69 74 73 20 76 65 | 72 73 61 74 69 6c 69 74 |e its ve|rsatilit|
|00001e40| 79 20 6d 61 6b 65 73 20 | 0a 73 65 74 74 69 6e 67 |y makes |.setting|
|00001e50| 20 75 70 20 61 20 64 6f | 63 75 6d 65 6e 74 20 73 | up a do|cument s|
|00001e60| 65 65 6d 20 6d 6f 72 65 | 20 63 6f 6d 70 6c 69 63 |eem more| complic|
|00001e70| 61 74 65 64 20 74 68 61 | 6e 20 69 74 20 72 65 61 |ated tha|n it rea|
|00001e80| 6c 6c 79 20 69 73 2e 0a | 0a 49 66 20 77 68 61 74 |lly is..|.If what|
|00001e90| 20 79 6f 75 20 77 61 6e | 74 20 74 6f 20 64 6f 20 | you wan|t to do |
|00001ea0| 69 6e 20 6f 6e 65 20 64 | 6f 63 75 6d 65 6e 74 20 |in one d|ocument |
|00001eb0| 69 73 20 6d 61 69 6e 6c | 79 20 77 6f 72 64 70 72 |is mainl|y wordpr|
|00001ec0| 6f 63 65 73 73 69 6e 67 | 20 77 69 74 68 20 61 20 |ocessing| with a |
|00001ed0| 0a 66 65 77 20 6f 66 20 | 74 68 65 20 73 70 72 65 |.few of |the spre|
|00001ee0| 61 64 73 68 65 65 74 20 | 66 61 63 69 6c 69 74 69 |adsheet |faciliti|
|00001ef0| 65 73 20 69 6e 63 6c 75 | 64 65 64 2c 20 74 68 65 |es inclu|ded, the|
|00001f00| 6e 20 69 74 20 69 73 20 | 62 65 74 74 65 72 20 74 |n it is |better t|
|00001f10| 6f 20 73 65 74 20 0a 74 | 68 65 20 46 69 6c 65 20 |o set .t|he File |
|00001f20| 2d 20 4f 70 74 69 6f 6e | 73 20 64 69 66 66 65 72 |- Option|s differ|
|00001f30| 65 6e 74 6c 79 20 66 72 | 6f 6d 20 6f 6e 65 20 77 |ently fr|om one w|
|00001f40| 68 69 63 68 20 69 73 20 | 74 6f 20 62 65 20 75 73 |hich is |to be us|
|00001f50| 65 64 20 6d 61 69 6e 6c | 79 20 61 73 20 61 20 0a |ed mainl|y as a .|
|00001f60| 73 70 72 65 61 64 73 68 | 65 65 74 2e 20 20 49 6e |spreadsh|eet.  In|
|00001f70| 20 70 61 72 74 69 63 75 | 6c 61 72 2c 20 75 6e 6e | particu|lar, unn|
|00001f80| 65 63 65 73 73 61 72 79 | 20 64 69 66 66 69 63 75 |ecessary| difficu|
|00001f90| 6c 74 69 65 73 20 61 62 | 6f 75 74 20 73 75 63 68 |lties ab|out such|
|00001fa0| 20 74 68 69 6e 67 73 20 | 0a 61 73 20 77 68 65 74 | things |.as whet|
|00001fb0| 68 65 72 20 63 65 6c 6c | 73 20 65 78 70 65 63 74 |her cell|s expect|
|00001fc0| 20 74 68 65 69 72 20 66 | 69 72 73 74 20 65 6e 74 | their f|irst ent|
|00001fd0| 72 79 20 74 6f 20 62 65 | 20 6c 65 66 74 20 61 6c |ry to be| left al|
|00001fe0| 69 67 6e 65 64 20 74 65 | 78 74 20 6f 72 20 0a 72 |igned te|xt or .r|
|00001ff0| 69 67 68 74 20 61 6c 69 | 67 6e 65 64 20 6e 75 6d |ight ali|gned num|
|00002000| 65 72 69 63 61 6c 20 76 | 61 6c 75 65 73 20 61 72 |erical v|alues ar|
|00002010| 69 73 65 20 62 65 63 61 | 75 73 65 20 74 68 65 20 |ise beca|use the |
|00002020| 46 69 6c 65 20 2d 20 4f | 70 74 69 6f 6e 73 20 68 |File - O|ptions h|
|00002030| 61 76 65 20 0a 62 65 65 | 6e 20 69 6e 61 70 70 72 |ave .bee|n inappr|
|00002040| 6f 70 72 69 61 74 65 6c | 79 20 73 65 74 2e 0a 0a |opriatel|y set...|
|00002050| 41 6c 6d 6f 73 74 20 61 | 6e 79 20 73 65 74 20 6f |Almost a|ny set o|
|00002060| 66 20 4f 70 74 69 6f 6e | 73 20 63 61 6e 20 62 65 |f Option|s can be|
|00002070| 20 70 72 65 73 65 74 20 | 62 79 20 75 73 69 6e 67 | preset |by using|
|00002080| 20 61 20 4d 61 63 72 6f | 20 2d 20 62 75 74 2c 20 | a Macro| - but, |
|00002090| 69 74 20 69 73 20 0a 75 | 6e 66 6f 72 74 75 6e 61 |it is .u|nfortuna|
|000020a0| 74 65 20 66 6f 72 20 74 | 68 65 20 62 65 67 69 6e |te for t|he begin|
|000020b0| 6e 65 72 20 74 68 61 74 | 20 6d 61 63 72 6f 73 20 |ner that| macros |
|000020c0| 61 72 65 20 61 20 50 69 | 70 65 44 72 65 61 6d 20 |are a Pi|peDream |
|000020d0| 66 61 63 69 6c 69 74 79 | 20 62 65 73 74 20 0a 74 |facility| best .t|
|000020e0| 61 63 6b 6c 65 64 20 6c | 61 74 65 72 20 72 61 74 |ackled l|ater rat|
|000020f0| 68 65 72 20 74 68 61 6e | 20 65 61 72 6c 69 65 72 |her than| earlier|
|00002100| 20 69 6e 20 74 68 65 20 | 6c 65 61 72 6e 69 6e 67 | in the |learning|
|00002110| 20 70 72 6f 63 65 73 73 | 2e 20 20 52 6f 62 65 72 | process|.  Rober|
|00002120| 74 20 68 61 73 20 0a 70 | 72 6f 76 69 64 65 64 20 |t has .p|rovided |
|00002130| 61 20 63 6f 75 70 6c 65 | 20 6f 66 20 6d 61 63 72 |a couple| of macr|
|00002140| 6f 73 2c 20 6f 6e 65 20 | 77 68 65 72 65 20 74 68 |os, one |where th|
|00002150| 65 20 6f 70 74 69 6f 6e | 73 20 61 72 65 20 6d 6f |e option|s are mo|
|00002160| 72 65 20 73 75 69 74 65 | 64 20 74 6f 20 61 20 0a |re suite|d to a .|
|00002170| 53 70 72 65 61 64 73 68 | 65 65 74 20 28 63 61 6c |Spreadsh|eet (cal|
|00002180| 6c 65 64 20 6e 65 77 5f | 73 68 65 65 74 29 20 61 |led new_|sheet) a|
|00002190| 6e 64 20 6f 6e 65 20 6d | 6f 72 65 20 73 75 69 74 |nd one m|ore suit|
|000021a0| 65 64 20 74 6f 20 61 20 | 77 6f 72 64 70 72 6f 63 |ed to a |wordproc|
|000021b0| 65 73 73 6f 72 20 0a 28 | 63 61 6c 6c 65 64 20 6e |essor .(|called n|
|000021c0| 65 77 5f 77 6f 72 64 29 | 2e 20 20 54 6f 20 52 55 |ew_word)|.  To RU|
|000021d0| 4e 20 61 20 6d 61 63 72 | 6f 20 61 6c 6c 20 79 6f |N a macr|o all yo|
|000021e0| 75 20 6e 65 65 64 20 74 | 6f 20 64 6f 20 69 73 20 |u need t|o do is |
|000021f0| 64 6f 75 62 6c 65 20 63 | 6c 69 63 6b 20 0a 77 69 |double c|lick .wi|
|00002200| 74 68 20 74 68 65 20 6d | 6f 75 73 65 20 73 65 6c |th the m|ouse sel|
|00002210| 65 63 74 20 28 6c 65 66 | 74 29 20 62 75 74 74 6f |ect (lef|t) butto|
|00002220| 6e 20 6f 6e 20 74 68 65 | 20 6d 61 63 72 6f 20 61 |n on the| macro a|
|00002230| 6e 64 20 69 74 20 77 69 | 6c 6c 20 72 75 6e 20 0a |nd it wi|ll run .|
|00002240| 63 61 72 72 79 69 6e 67 | 20 6f 75 74 20 61 6c 6c |carrying| out all|
|00002250| 20 69 74 73 20 66 75 6e | 63 74 69 6f 6e 73 2e 20 | its fun|ctions. |
|00002260| 20 54 72 79 20 74 68 65 | 20 6d 61 63 72 6f 20 6e | Try the| macro n|
|00002270| 65 77 5f 77 6f 72 64 20 | 61 6e 64 20 79 6f 75 20 |ew_word |and you |
|00002280| 77 69 6c 6c 20 0a 68 61 | 76 65 20 61 20 27 64 65 |will .ha|ve a 'de|
|00002290| 66 61 75 6c 74 27 20 77 | 6f 72 64 20 70 72 6f 63 |fault' w|ord proc|
|000022a0| 65 73 73 6f 72 20 64 6f | 63 75 6d 65 6e 74 2c 20 |essor do|cument, |
|000022b0| 64 6f 75 62 6c 65 20 63 | 6c 69 63 6b 20 6f 6e 20 |double c|lick on |
|000022c0| 6e 65 77 5f 73 68 65 65 | 74 20 61 6e 64 20 0a 79 |new_shee|t and .y|
|000022d0| 6f 75 20 77 69 6c 6c 20 | 68 61 76 65 20 61 20 64 |ou will |have a d|
|000022e0| 65 66 61 75 6c 74 20 73 | 70 72 65 61 64 73 68 65 |efault s|preadshe|
|000022f0| 65 74 2e 20 20 59 6f 75 | 20 6d 61 79 20 74 68 65 |et.  You| may the|
|00002300| 6e 20 63 68 61 6e 67 65 | 20 74 68 65 20 4f 70 74 |n change| the Opt|
|00002310| 69 6f 6e 73 20 0a 66 75 | 72 74 68 65 72 20 69 66 |ions .fu|rther if|
|00002320| 20 79 6f 75 20 77 69 73 | 68 20 62 75 74 20 79 6f | you wis|h but yo|
|00002330| 75 20 77 69 6c 6c 20 6e | 6f 74 20 62 65 20 61 62 |u will n|ot be ab|
|00002340| 6c 65 20 74 6f 20 73 61 | 76 65 20 79 6f 75 72 20 |le to sa|ve your |
|00002350| 6e 65 77 20 4f 70 74 69 | 6f 6e 20 0a 73 65 74 20 |new Opti|on .set |
|00002360| 61 73 20 61 20 63 68 61 | 6e 67 65 64 20 6e 65 77 |as a cha|nged new|
|00002370| 5f 77 6f 72 64 20 6f 72 | 20 6e 65 77 5f 73 68 65 |_word or| new_she|
|00002380| 65 74 20 6d 61 63 72 6f | 2e 20 20 54 6f 20 63 68 |et macro|.  To ch|
|00002390| 61 6e 67 65 20 74 68 65 | 20 6d 61 63 72 6f 20 79 |ange the| macro y|
|000023a0| 6f 75 20 0a 6e 65 65 64 | 20 74 6f 20 6c 65 61 72 |ou .need| to lear|
|000023b0| 6e 20 61 20 72 61 6e 67 | 65 20 6f 66 20 27 45 64 |n a rang|e of 'Ed|
|000023c0| 69 74 69 6e 67 20 6d 61 | 63 72 6f 27 20 73 6b 69 |iting ma|cro' ski|
|000023d0| 6c 6c 73 2e 0a 0a 46 69 | 6e 61 6c 6c 79 2c 20 69 |lls...Fi|nally, i|
|000023e0| 66 20 79 6f 75 20 68 61 | 76 65 20 61 20 70 61 72 |f you ha|ve a par|
|000023f0| 74 69 63 75 6c 61 72 20 | 72 65 71 75 69 72 65 6d |ticular |requirem|
|00002400| 65 6e 74 20 66 6f 72 20 | 61 20 27 53 74 61 72 74 |ent for |a 'Start|
|00002410| 75 70 20 4d 61 63 72 6f | 27 20 0a 77 68 69 63 68 |up Macro|' .which|
|00002420| 20 75 73 65 73 20 61 20 | 73 65 74 20 6f 66 20 46 | uses a |set of F|
|00002430| 69 6c 65 20 2d 20 4f 70 | 74 69 6f 6e 73 20 74 68 |ile - Op|tions th|
|00002440| 61 74 20 79 6f 75 20 6c | 69 6b 65 20 62 75 74 2c |at you l|ike but,|
|00002450| 20 61 73 20 79 65 74 2c | 20 79 6f 75 20 0a 68 61 | as yet,| you .ha|
|00002460| 76 65 6e 27 74 20 74 68 | 65 20 73 6b 69 6c 6c 20 |ven't th|e skill |
|00002470| 74 6f 20 77 72 69 74 65 | 20 69 74 2c 20 74 68 65 |to write| it, the|
|00002480| 6e 20 73 65 6e 64 20 6d | 65 20 61 20 66 6f 72 6d |n send m|e a form|
|00002490| 61 74 74 65 64 20 64 69 | 73 63 20 28 70 6c 75 73 |atted di|sc (plus|
|000024a0| 20 0a 72 65 74 75 72 6e | 20 70 6f 73 74 61 67 65 | .return| postage|
|000024b0| 20 61 6e 64 20 61 20 73 | 65 6c 66 20 61 64 64 72 | and a s|elf addr|
|000024c0| 65 73 73 65 64 20 73 74 | 69 63 6b 79 20 6c 61 62 |essed st|icky lab|
|000024d0| 65 6c 29 20 77 69 74 68 | 20 61 6e 20 65 78 61 6d |el) with| an exam|
|000024e0| 70 6c 65 20 6f 66 20 61 | 20 0a 66 69 6c 65 20 68 |ple of a| .file h|
|000024f0| 61 76 69 6e 67 20 74 68 | 65 20 6f 70 74 69 6f 6e |aving th|e option|
|00002500| 73 20 73 65 74 20 74 68 | 61 74 20 79 6f 75 20 77 |s set th|at you w|
|00002510| 61 6e 74 20 61 6e 64 20 | 49 27 6c 6c 20 73 65 6e |ant and |I'll sen|
|00002520| 64 20 79 6f 75 20 62 61 | 63 6b 20 74 68 65 20 0a |d you ba|ck the .|
|00002530| 64 69 73 63 20 77 69 74 | 68 20 61 20 6d 61 63 72 |disc wit|h a macr|
|00002540| 6f 20 74 6f 20 64 6f 20 | 74 68 65 20 6a 6f 62 2e |o to do |the job.|
|00002550| 20 20 4f 66 20 63 6f 75 | 72 73 65 20 79 6f 75 20 |  Of cou|rse you |
|00002560| 68 61 76 65 20 74 6f 20 | 62 65 20 61 20 50 69 70 |have to |be a Pip|
|00002570| 65 4c 69 6e 65 20 0a 73 | 75 62 73 63 72 69 62 65 |eLine .s|ubscribe|
|00002580| 72 20 74 6f 20 74 61 6b | 65 20 61 64 76 61 6e 74 |r to tak|e advant|
|00002590| 61 67 65 20 6f 66 20 74 | 68 69 73 20 66 72 65 65 |age of t|his free|
|000025a0| 20 73 65 72 76 69 63 65 | 20 62 75 74 20 49 20 74 | service| but I t|
|000025b0| 68 69 6e 6b 20 74 68 61 | 74 27 73 20 0a 6f 6e 6c |hink tha|t's .onl|
|000025c0| 79 20 66 61 69 72 2e 0a |                         |y fair..|        |
+--------+-------------------------+-------------------------+--------+--------+